Reverse Engineering Relational Schemas to Object-Oriented Schemas
نویسندگان
چکیده
Due to the wide use of object-oriented technology in software development, reverse engineering of relational schemas to object-oriented schemas is gaining a lot of interest. One of the major problems with existing approaches for this schema mapping is the extensive amount of information that must be gathered either automatically or from the user. This paper presents an object-centered approach (as opposed to other relation-centered approaches) for doing the schema mapping. The procedure maps a 3NF relational schema into an object-oriented schema without the explicit use of inclusion dependencies and provides a greater scope for automation.
منابع مشابه
Extraction of Object-oriented Schemas from Existing Relational Databases: a Form-driven Approach
In this paper, we present our Form-driven approach for reverse engineering of relationa databases. This methodology uses the information extracted from both form structure and instances as a database reverse engineering input using an interaction with a user. Through a combination of forms structures and data instances analysis, forms relational sub-schemas and their constraints are derived. Th...
متن کاملUML Specification of Relational Database
Database reverse engineering (DBRE) recovers a database design using a semantic data model. Most of the existing works and tools for DBRE and database design specify relational database schemas with extended ER models. The Unified Modeling Language (UML) is a standard language for modeling software and database systems. We discuss how to extend the UML metamodel with elements for modeling relat...
متن کاملAn Object Query Language for Multimedia Federations
The F́ıschlár system provides a large centralised repository of multimedia files. As expansion is difficult in centralised systems and as different user groups have a requirement to define their own schemas, the EGTV (Efficient Global Transactions for Video) project was established to examine how the distribution of this database could be managed. The federated database approach is advocated whe...
متن کاملRelational Database Reverse Engineering: Extraction of an IFO2 Schema
The first step for developing an heterogeneous federated database consists in translating local schemas into a canonical data model. This paper offers a method to transform a relational schema into an equivalent object-oriented one. We study in particular the translation of the nary relationship tables (n>2). The canonical data model we are using is the IFO2 data model [16], [17], [24]. We tran...
متن کاملTranslating Relational Schemas into Object-based/XML Schemas
This paper proposes an approach for translating an existing relational database (RDB) schema into relatively newer database (i.e., object-oriented, object-relational and XML) schemas, based on available standards. The approach is superior to existing proposals as it generates three different and equivalent target schemas. The solution takes an RDB as input, enriches its metadata representation ...
متن کامل